﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'SelectClientePorGuid')
	BEGIN
		DROP  Procedure  SelectClientePorGuid
	END

GO

CREATE Procedure SelectClientePorGuid

	(
		@GuidID uniqueidentifier
	)

AS
BEGIN
	SET NOCOUNT ON

	SELECT
	[IdCliente],
	[UserID],
	[Dni],
	[Nombre],
	[Apellidos],
	[Ruc],
	[RazonSocial],
	[IdDistrito],
	[Direccion],
	[Email],
	[Telefono],
	[Celular],
	[FechaNacimiento],
	[Sexo],
	[Ocupacion],
	[Foto]
	FROM [Cliente]
	WHERE [UserID] = @GuidID

	SET NOCOUNT OFF
END

GO


GRANT EXEC ON SelectClientePorGuid TO PUBLIC

GO


